import {MigrationInterface, QueryRunner} from "typeorm";
2
3
export class Voucher1617438352492 implements MigrationInterface {
4
name = 'Voucher1617438352492'
5
6
public async up(queryRunner: QueryRunner): Promise<void> {
7
await queryRunner.query(`CREATE TABLE "voucher" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "code" character varying NOT NULL, "email" character varying NOT NULL, "createdAt" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, "schoolId" uuid NOT NULL, CONSTRAINT "PK_677ae75f380e81c2f103a57ffaf" PRIMARY KEY ("id"))`);
8
await queryRunner.query(`ALTER TABLE "voucher" ADD CONSTRAINT "FK_c837a392c774db4d54bc8d8484c" FOREIGN KEY ("schoolId") REFERENCES "school"("id") ON DELETE CASCADE ON UPDATE NO ACTION`);
9
}
10
11
public async down(queryRunner: QueryRunner): Promise<void> {
12
await queryRunner.query(`ALTER TABLE "voucher" DROP CONSTRAINT "FK_c837a392c774db4d54bc8d8484c"`);
fairnesscoop /
pictyschool
